public class DTSpreadsheet
| Constructor and Description |
|---|
DTSpreadsheet() |
DTSpreadsheet(BBjString sheetName!) |
| Modifier and Type | Method and Description |
|---|---|
void | addRow(BBjVector cells!) |
org.apache.poi.xssf.usermodel.XSSFCell | getCell(BBjInt rowNo%, BBjInt colNo%) |
BBjNumber | getCellAsDate(BBjInt rowNo%, BBjInt colNo%) |
BBjNumber | getCellAsNumber(BBjInt rowNo%, BBjInt colNo%) |
BBjString | getCellAsString(BBjInt rowNo%, BBjInt colNo%) |
BBjString | getErrMsg() |
org.apache.poi.xssf.usermodel.XSSFRow | getRow(BBjInt rowNo%) |
BBjString | getRowAsString() |
BBjVector | getRowAsVector() |
BBjVector | getSheetNames() |
BBjInt | open(BBjString filename!) |
BBjInt | open(BBjString filename!, BBjInt cvs!) |
void | save(BBjString filename!) |
BBjInt | selectSheet(BBjInt sheetNo%) |
void | setCell(BBjInt rowNo%, BBjInt colNo%, String value!) |
void | setCell(BBjInt rowNo%, BBjInt colNo%, BBjNumber value) |
void | setCellAsDate(BBjInt rowNo%, BBjInt colNo%, BBjNumber jDate) |
BBjString | sheetToCsvFile(BBjNumber sheetNo!, BBjString csvFilePath$) |
public DTSpreadsheet()
public DTSpreadsheet(BBjString sheetName!)public void addRow(BBjVector cells!)
public org.apache.poi.xssf.usermodel.XSSFCell getCell(BBjInt rowNo%, BBjInt colNo%)
public BBjNumber getCellAsDate(BBjInt rowNo%, BBjInt colNo%)public BBjNumber getCellAsNumber(BBjInt rowNo%, BBjInt colNo%)public BBjString getCellAsString(BBjInt rowNo%, BBjInt colNo%)public BBjString getErrMsg()public org.apache.poi.xssf.usermodel.XSSFRow getRow(BBjInt rowNo%)
public BBjString getRowAsString()public BBjVector getRowAsVector()public BBjVector getSheetNames()public BBjInt open(BBjString filename!)public BBjInt open(BBjString filename!, BBjInt cvs!)public void save(BBjString filename!)public BBjInt selectSheet(BBjInt sheetNo%)
public void setCell(BBjInt rowNo%, BBjInt colNo%, String value!)
public void setCell(BBjInt rowNo%, BBjInt colNo%, BBjNumber value)
public void setCellAsDate(BBjInt rowNo%, BBjInt colNo%, BBjNumber jDate)